package com.xln.furns.dao.impl;

import com.xln.furns.dao.LoginDAO;
import com.xln.furns.entity.Member;

public class LoginDAOimpl extends BasicDAO<Member> implements LoginDAO {
    @Override
    public Member queryMemberByUsernameAndPassword(String username, String password) {
        String sql = "SELECT `id`,`username`,`password`,`email` FROM `member`"+
                " WHERE `username`=? and `password`=MD5(?)";
        return querySingle(sql,Member.class,username,password);


    }
}
